/*-+-*****************************************************************************
 Copyright (C) 2009-2012 Oceanside Software Corporation (R)
 Dallas, Texas

 Author       : Jason T. Brower
 Purpose      : This file is part of a point-of-sale software package
                originally written for Table-Service Restaurants.
              
 Date         : July 8th of 2012
              
 History      : The application that this software file belongs to was 
                written over a 3-Year period.  The first version was written
                in C# .Net 3.5 using Windows Forms.  Being new to .Net at
                the time, I soon learned of Windows Presentation Foundation,
                liked the graphics capabilities and databinding so I
                migrated to WPF.  When the .Net 4.0 framework was released
                the application was migrated from 3.5 to 4.0. Now today,
                .Net 4.5 RC is out and I was already in process of migrating
                before I made this public.
                
Excuse Me     : Please excuse the coding style, it is not representative of
                my typical work.  During the three years I was under a very
                tight budget, constantly running out of funding and was 
                working 18 hour days hyped up on 5-Hour Energy.  The 
                design is not textbook.  It is monolythic because of
                previous issues I will not get into.  There are few comments
                in the code and the ones that are there may be incorrect.
                
What it is not: This is not the exact version that I took through PA-DSS 2.0
                nor is it the exact version running at my customer sites.
                I removed some details for security purposes including some
                encryption algorithms.  The reporting was removed because
                I was including a third party library that cannot be 
                published with this Open Source.
                
What it is    : This application has been running at high volume restaraunts
                for over a year.  It never freezes, crashes or does anything
                unexpected.  So long as it is built, installed and configured
                correctly, it is a strong system that we can all enhance.

Contact       : Please note that I can no longer work for free.  However, you
                can reach me at information@oceansidesw.com.                                                      

*********************************************************************************/
using System.Collections.Generic;
using System.Data.Objects;
using System.Data.Objects.DataClasses;
using System.Linq;
using System.Windows.Controls;
#if _LOCALDB
  using Oceanside.LocalDB;
#else
using Oceanside.RemoteDB;
#endif

namespace Oceanside
{
    /// <summary>
    /// Interaction logic for PageLogin.xaml
    /// </summary>
    public partial class PageAccessLevelsImp : PageImpBaseClass
    {
        ComboBox comboBoxName;
        DbLinkedTextBox textBoxName;

        /// <summary>
        /// Constructor
        /// </summary>
        public PageAccessLevelsImp(UIElementCollection elements, ComboBox cb, DbLinkedTextBox tb, GroupBox mainGroup)
            : base()
        {
            this.ButtonNumber = "2";
            this.ButtonLabelText = " Access Levels";
            this.comboBoxName = cb;
            this.textBoxName = tb;
            RegisterSaveMeGroupBoxes(null, mainGroup);

            mNewGroupIsDisabled = true;
            mDeleteGroupIsDisabled = true;
            mButtonNewEntityName = "New Access Level";
            mButtonDeleteEntityName = "Delete Access Level";

            ///Register the controls and lock the form.
            RegisterUiElementsList(elements);

            ///Add all text boxes to the list.
            mTextBoxesList.Add(textBoxName);

            ///Add the comboboxes.
            ListofComboboxes.Add(comboBoxName);

            mEntityAddDeleteLoggingEnabled = true;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        override public List<EntityObject> GetEntityObjectSet()
        {
            return new List<EntityObject>(Context.ACCESS_LEVELS.Where(a=>a.Name != null && !a.Name.Contains("Training")).OrderBy(o=>o.Name).ToList());
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public override EntityObject GetSelectedEntityObject()
        {
            ACCESS_LEVEL selected = comboBoxName.SelectedItem as ACCESS_LEVEL;
            return selected;
        }


        /// <summary>
        /// 
        /// </summary>
        public override void MarkEntityDeleted()
        {
            ACCESS_LEVEL selected = comboBoxName.SelectedItem as ACCESS_LEVEL;
            selected.IsDeleted = true;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="source"></param>
        public override void UpdateUsersEntitySource()
        {
            ///Create the query object.
            var query = from ACCESS_LEVEL in Context.ACCESS_LEVELS 
                        where ACCESS_LEVEL.IsDeleted == false &&
                        ACCESS_LEVEL.Name != null &&
                        !ACCESS_LEVEL.Name.Contains("Training")
                        orderby ACCESS_LEVEL.Name select ACCESS_LEVEL;

            if (query.Any())
            {
                List<ACCESS_LEVEL> list = query.ToList();
                comboBoxName.ItemsSource = list;
                if (list != null && list.Count != 0)
                {
                    comboBoxName.SelectedItem = list.First();
                }
                else
                {
                    comboBoxName.ItemsSource = null;
                }
            }
            else
            {
                comboBoxName.ItemsSource = null;
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public override EntityObject AddNewEntityObject()
        {
            ACCESS_LEVEL newObject = null;
            var q = from ACCESS_LEVEL in Context.ACCESS_LEVELS where ACCESS_LEVEL.Name.Equals("Not Assigned") select ACCESS_LEVEL;

            if (q.Count() == 0)
            {
                newObject = new ACCESS_LEVEL();
                newObject.Name = "Not Assigned";
                Context.ACCESS_LEVELS.AddObject(newObject);
            }
            else
            {
                newObject = q.First();
                if (newObject.IsDeleted)
                {
                    newObject.IsDeleted = false;
                }
            }

            return newObject;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public override ComboBox GetEntityComboBox()
        {
            return comboBoxName;
        }
    }
}
